//
//  2017-6-6 质量检查结果 本地存储表
//
//  

#import <Foundation/Foundation.h>
#import "HQc_codeModel.h"
#import "Model_Hr_SatType.h"
@interface InitDbTableQuality : NSObject

-(NSString*) GetMainTableSql;
-(NSString*) GetDetailTableSql;

-(NSMutableArray *) GetMainTableWithUpload_flag:(NSInteger )upload_flag
                                        typy_id:(NSString *)type_id
                                      level_id :(NSString *)level_id;

-(NSMutableArray *) GetDetailIUnUploadTable;

//根据查询到的已上传,和未上传还找到code_name
- (HQc_codeModel *)GetCodeNameWithCodeID:(NSString *)code_id;


- (NSMutableArray *)GetCheckDate;

//删除操作

- (void)deleteTableWithResult_id:(NSString *)result_id;

//更新操作
- (void)UpdateTableWithResult_id:(NSString *)result_id;

//获取保存之后 可编辑的明细表
- (NSMutableArray *)GetDetailInspectTableWithResult:(NSString *)result_ID;

//获取保存之后 可编辑的主表
- (NSMutableArray *)GetInspectNewTableWithResult:(NSString *)result_ID;



//操作过程考核查询
-(NSMutableArray *) GetMainTableWithAssessUpload_flag:(NSInteger )upload_flag
                                              typy_id:(NSString *)type_id
                                             level_id:(NSString *)level_id;

//获取操作过程考核明细表
-(NSMutableArray *) GetDetailIAssessUnUploadTable;


//提交满意度调查明细表
- (NSMutableArray *)GetmanyiduUnUploadTable;


//查找满意度type
- (Model_Hr_SatType *)GetHSaNameWithCodeID:(NSString *)code_id;

//删除满意度
- (void)deleteTableWithHSaTableCode:(NSString *)table_code;
//上传成功后 更改满意度upload

- (void)UpdateTableWithHSaTableCode:(NSString *)table_code;

//查找上传成功后的指标表
- (NSMutableArray *)GetInspextNewWithReslut_id:(NSString *)reslut_id code_id:(NSString *)code_id;

- (NSMutableArray *)getInspextNewWithReslut_id:(NSArray *)reslut_id;



//质量检查 满足4级指标之后  可再次编辑功能
- (NSMutableArray *)GetDetailInspectTableWithResultAndPar_id:(NSString *)result_ID
                                                      par_id:(NSString *)par_id;

//质量检查查找扣分原因
- (NSMutableArray *)getChooseReasonsWithCode_id:(NSString *)code_id;
@end
